exports.storeTable = [
  /**
  * 添加店铺
  */
  {
    sql:
      `
        CREATE TABLE IF NOT EXISTS store (
            id INT AUTO_INCREMENT PRIMARY KEY,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            name VARCHAR(100) NOT NULL,
            desc_content TEXT,
            logo VARCHAR(255) NOT NULL,
            video VARCHAR(255),
            banner JSON,
            url VARCHAR(255) NOT NULL,
            phone VARCHAR(20) NOT NULL,
            store_address VARCHAR(255) NOT NULL,
            self_carry_address  VARCHAR(255),
            status INT DEFAULT 1,
            is_carry INT DEFAULT 1 CHECK (is_carry IN (0, 1)),
            fans INT DEFAULT 0,
            is_open INT DEFAULT 1 CHECK (is_open IN (0, 1)),
            clerk JSON,
            distribution JSON,
            is_recommend INT NOT NULL DEFAULT 0 CHECK (is_recommend IN (0, 1)),
            is_new INT NOT NULL DEFAULT 0 CHECK (is_new IN (0, 1)),
            is_hot INT NOT NULL DEFAULT 0 CHECK (is_hot IN (0, 1)),
            is_delete INT NOT NULL DEFAULT 0 CHECK (is_delete IN (0, 1))
          )
      `,
    name: '店铺store'
  },
]